package mybatisdemo.mapper;

import mybatisdemo.po.Orders;
import mybatisdemo.po.OrdersCustom;
import mybatisdemo.po.User;

import java.util.List;

/**
 * Created by 隼 on 2016/12/6.
 * 订单mapper
 */
public interface OrdersMapperCustom {
    //查询订单关联查询用户信息
    public List<OrdersCustom> findOrdersUser()throws Exception;

    //查询订单关联查询用户信息，使用resultMap
    public List<Orders> findOrdersUserResultMap() throws  Exception;

    //查询订单(关联用户)及订单明细信息，使用resultMap

    public List<Orders> findOrdersAndOrderDetailResultMap()throws Exception;

    //查询用户购买商品信息
    public List<User> findUserAndItemsResultMap() throws Exception;

    //查询订单关联查询用户，用户信息是延迟加载
    public List<Orders> findOrdersUserLazyLoading()throws Exception;
}
